Shark Bay — Bitterns Recycling Field Piping

saved locally

Forecast GM%

—

Actual GM% (to date)

—

Cash on job (received − costs)

—

director's rule: never negative

Cost burn — forecast vs actual (by section)

thick bar = forecast · thin bar = actual (red when over)

What's still owed to us

Invoice & cash timeline — the plan

▦ invoice raised that month · ▦ cash lands (30 days from invoice month-end) · ▦ costs attached to that claim

⬇ Drop the 2iB PO Detail Report (CSV) — auto-filters to DTL-PRJ0072, matches supplier costs to forecast lines.
(click to browse)

Forecast vs Actual — every Costings line

Blue cells: forecast cost + % complete. ▸ opens the matched supplier costs (re-taggable). Labour actuals live on the Labour page and roll into totals here.

Crew forecast vs actual — hours & cost by role

Forecast from the Costings Model (hours × internal cost rate). Add actual hours from your weekly labour summary below — cost auto-computes at the role's rate.

Weekly labour entries

Progress claims — the director's plan

A claim counts as INVOICED once you fill its invoice ref/date. Cash expected 30 days from invoice month-end (FIME).

→ Hand-off to the Cash-Flow Calendar

These are the exact rows to place on the cashflow forecast: revenue on its expected cash date, that claim's costs on their pay date. Copy to Claude when you're happy and they go on the calendar.

Costs associated with each claim

Attach the supplier/labour cost that belongs to each claim (what we must pay out of that claim's cash). Seeded at forecast cost ratio — overwrite with real numbers as they firm up.